Untitled Spreadsheet

DETAILED SALES REPORT

			STATION:		Taft																REVENUE DATE :					08/05/2014

Name of	I.D.	Name of	Single Journey (SJ)		Discounted (DSJ)		Discounted (DSV)		Stored Value (SV)		Fare	O.T.	Total	Unreg.	Discount									OVER(LACKING)				DEFECTIVE TICKET
CA	No.	Ticket Seller	Tickets	Amount	Tickets	Amount	Tickets	Amount	Tickets	Amount	Adj.	Amt.	Amount	Sale	SJ	SV	Refund				Overage	Shortage		OVER(LACKING)				DEFECTIVE TICKET
			Sold	(P)	Sold	(P)	Sold	(P)	Sold	(P)	Amt.				SJ	SV	SJ	Amt.	SV	Amt.		PD	UPD	SJ	DSJ	DSV	SV	SJ	DSJ	DSV	SV
BUNITE, MARLON	2956	PINEDA, ERNESTO JR	12	0	11	0	11	1100.00	12	1200.00	0	0	2300.00	0	0	0	0	0	0	0	2216700.00	0	0	0	(2)	0	0	0	0	0	0
Subtotal			12	0	11	0	11	1100.00	12	1200.00	0	0	2300.00	0	0	0	0	0	0	0	2216700.00	0	0	0	(2)	0	0	0	0	0	0
Grand Total			12	0	11	0	11	1100.00	12	1200.00	0	0	2300.00	0	0	0	0	0	0	0	2216700.00	0	0	0	(2)	0	0	0	0	0	0



Summary
Total Sales				Tickets			SJT	DSJT	SVT	DSVT				Cash Beg. Balance PHP							(1516630.00)				DEPOSIT SLIP NO.
SJ	PHP	0		Beginning Balance			34	(33)	0	0				Add: Fixed Stn - Fund							28000.00
DSJ+DSV		1100.00		Initial Allocation			0	0	0	0				Net Sales							2300.00
SV		1200.00		Additional			0	0	0	0				Total							(1486330.00)
F.A.		0		Total			34	(33)	0	0				Less: PNB (Current)							0
O.T.		0		Less: Tickets Sold			12	11	12	11				PNB (Previous)							200000000.00
Unreg. Sale		0		Physically Defective			0	0	0	0				Cash b-4 short/over							(201486330.00)
GrandTotal		2300.00		Defective Tickets			0	0	0	0				Add: Overages							2216700.00
Less: Refund		0		Add: Over/(Lacking)			0	(2)	0	0				Less: Unpaid Shortages							0
Discount		0		Ending Balance			22	(46)	(12)	(11)				Cash Ending Balance PHP							(199269630.00)
NET SALES	PHP	2300.00


Certified Correct:	BUNITE, MARLON									Certified Correct:		BUNITE, MARLON								Certified Correct:			BUNITE, MARLON
Signature Over Printed Name (S1)										Signature Over Printed Name (S2)													Signature Over Printed Name (S3)